Tabela Discounts

Definicja tabeli Discounts

Name

Discounts

Code

Discounts

Comment

 


Lista kolumn tabeli Discounts

Name

Code

DiscountID

DiscountID

PriceID

PriceID

StartDT

StartDT

StopDT

StopDT

Discount

Discount


Kolumna DiscountID tabeli Discounts

Definicja kolumny DiscountID tabeli Discounts

Name

DiscountID

Code

DiscountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PriceID tabeli Discounts

Definicja kolumny PriceID tabeli Discounts

Name

PriceID

Code

PriceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Discounts

Definicja kolumny StartDT tabeli Discounts

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Discounts

Definicja kolumny StopDT tabeli Discounts

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Discount tabeli Discounts

Definicja kolumny Discount tabeli Discounts

Name

Discount

Code

Discount

Data Type

NUMBER(5,2)

Mandatory

No

Comment

 


Lista kluczy tabeli Discounts

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Discounts

Definicja klucza Identifier_1 tabeli Discounts

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment